home *** CD-ROM | disk | FTP | other *** search
- 0, In this demonstration, you will see how to use the
- 5, ODBC configuration utility to create a data
- 9, source name. To start the ODBC utility, from the
- 12, Control Panel double-click the ODBC icon. The ODBC Data
- 18, Source Admininstrator displays the data source
- 20, names currently defined on this system. The User DSNs
- 25, are names that are local to a computer and may
- 28, only be used by the current user. We'll create a
- 31, System DSN which will be available to any user. To
- 36, add a DSN, click Add, select the driver for your
- 42, database, you must have the appropriate ODBC driver
- 47, for your database, I'll choose SQL Server, and
- 50, click Finish. Here, I'll enter a name for the data
- 54, source, we'll call this StateU2, and a description ù
- 60, Class Database ù and the name of the server, the SQL
- 66, server, that has this database. If I click
- 72, Options, I can specify which database on that server I
- 78, want to access. And click OK. Now I've added a new
- 86, data source name to my system. In addition to
- 91, creating system DSNs, you can create file DSNs. When
- 95, you create a file DSN, the information is saved to
- 99, a text file rather than to the registry. When you
- 103, add a data connection in Visual InterDev, you can
- 106, use either type of DSN. So in this demonstration,
- 112, you have seen how to use the ODBC Data Source
- 115, Administrator to create a data source name. Now that
- 119, you have a data source name defined in Visual
- 122, InterDev, you can add a data connection to your
- 125, project.
- 129, END